Copying and Pasting from Micronet to Excel (v2.8)

You can use the standard copy and paste functions (Ctrl+C to cut and Ctrl+V to paste) to copy data from Micronet into a Microsoft Excel spreadsheet. This allows you, for example, to copy all lines from a sales order or a list of inventory items and their stock levels to Excel.

The copy and paste functions work in any Micronet screens that contain list boxes. For example:

• any screen with Add, Insert and Delete buttons such as the Invoice Creation screen and the Item Update screen - Purchasing tab

• partial key search screens such as the Item Selection screen and Purchase Order Selection screen

To copy and paste list data from Micronet to Excel:

1. Select any line in the list box then press Ctrl+C.

Micronet copies the visible data to the Windows clipboard. If you want to copy additional lines that aren't currently displayed, you need to repeat the cut and paste process after you have pasted this initial data into Excel.

2. Open an Excel spreadsheet, select the starting cell to paste the content into and press Ctrl+V.

Micronet copies the visible data into the Excel spreadsheet where you can manipulate it as required. This screen shows the data copied from the Item Selection screen shown above.

Excel

3. To copy additional lines that aren't currently displayed, scroll down to display the next lines to be copied, select a line and then copy and paste again.

Technical Tip You can use a free clipboard viewer (available at http://freeclipboardviewer.com/) to see the current content of the MS Windows clipboard as a preview or in specific clipboard data formats i.e. CF_TEXT.